package com.comleader.operator.pojo.entity;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.mybatisflex.annotation.Column;
import com.mybatisflex.annotation.Id;
import com.mybatisflex.annotation.KeyType;
import com.mybatisflex.annotation.Table;

import lombok.Data;

/**
 * 个人用户表 实体类。
 *
 * @author 连新景
 * @since 1.0
 */
@Data
@Table(value = "personal_user")
public class PersonalUserEntity{

    /**
     * 主键ID
     */
    @ExcelIgnore
    @Id(keyType = KeyType.Auto)
    private Long id;

    /**
     * 文件内行号
     */
    @ExcelIgnore
    @Column(value = "line_num")
    private Integer lineNum;

    /**
     * 机主姓名
     */
    @ExcelProperty("机主姓名")
    @Column(value = "owner_name")
    private String ownerName;

    /**
     * 机主证件类型
     */
    @ExcelProperty("机主证件类型")
    @Column(value = "owner_id_type")
    private String ownerIdType;

    /**
     * 机主证件号码
     */
    @ExcelProperty("机主证件号码")
    @Column(value = "owner_id_number")
    private String ownerIdNumber;

    /**
     * 机主证件地址
     */
    @ExcelProperty("机主证件地址")
    @Column(value = "owner_id_address")
    private String ownerIdAddress;

    /**
     * 机主通讯地址
     */
    @ExcelProperty("机主通讯地址")
    @Column(value = "owner_mailing_address")
    private String ownerMailingAddress;

    /**
     * 机主装机地址
     */
    @ExcelProperty("机主装机地址")
    @Column(value = "owner_install_address")
    private String ownerInstallAddress;

    /**
     * 代办人姓名
     */
    @ExcelProperty("代办人姓名")
    @Column(value = "agent_name")
    private String agentName;

    /**
     * 代办人证件类型
     */
    @ExcelProperty("代办人证件类型")
    @Column(value = "agent_id_type")
    private String agentIdType;

    /**
     * 代办人证件号码
     */
    @ExcelProperty("代办人证件号码")
    @Column(value = "agent_id_number")
    private String agentIdNumber;

    /**
     * 代办人证件地址
     */
    @ExcelProperty("代办人证件地址")
    @Column(value = "agent_id_address")
    private String agentIdAddress;

    /**
     * 代办人通讯地址
     */
    @ExcelProperty("代办人通讯地址")
    @Column(value = "agent_mailing_address")
    private String agentMailingAddress;

    /**
     * 责任人姓名
     */
    @ExcelProperty("责任人姓名")
    @Column(value = "pic_name")
    private String picName;

    /**
     * 责任人证件类型
     */
    @ExcelProperty("责任人证件类型")
    @Column(value = "pic_id_type")
    private String picIdType;

    /**
     * 责任人证件号码
     */
    @ExcelProperty("责任人证件号码")
    @Column(value = "pic_id_number")
    private String picIdNumber;

    /**
     * 责任人证件地址
     */
    @ExcelProperty("责任人证件地址")
    @Column(value = "pic_id_address")
    private String picIdAddress;

    /**
     * 责任人通讯地址
     */
    @ExcelProperty("责任人通讯地址")
    @Column(value = "pic_mailing_address")
    private String picMailingAddress;

    /**
     * 单位名称
     */
    @ExcelProperty("单位名称")
    @Column(value = "company_name")
    private String companyName;

    /**
     * 单位证件号码
     */
    @ExcelProperty("单位证件号码")
    @Column(value = "company_id_number")
    private String companyIdNumber;

    /**
     * 单位证件类型
     */
    @ExcelProperty("单位证件类型")
    @Column(value = "company_id_type")
    private String companyIdType;

    /**
     * 单位证件地址
     */
    @ExcelProperty("单位证件地址")
    @Column(value = "company_id_address")
    private String companyIdAddress;

    /**
     * 单位通讯地址
     */
    @ExcelProperty("单位通讯地址")
    @Column(value = "company_mailing_address")
    private String companyMailingAddress;

    /**
     * 单位装机地址
     */
    @ExcelProperty("单位装机地址")
    @Column(value = "company_install_address")
    private String companyInstallAddress;

    /**
     * 用户号码
     */
    @ExcelProperty("用户号码")
    @Column(value = "user_number")
    private String userNumber;

    /**
     * 号码日期(登记/激活/过户)
     */
    @ExcelProperty("号码日期(登记/激活/过户)")
    @Column(value = "number_date")
    private String numberDate;

    /**
     * 号码状态
     */
    @ExcelProperty("号码状态")
    @Column(value = "number_status")
    private String numberStatus;

    /**
     * 用户业务类型
     */
    @ExcelProperty("用户业务类型")
    @Column(value = "user_business_type")
    private String userBusinessType;

    /**
     * 营业网点编号
     */
    @ExcelProperty("营业网点编号")
    @Column(value = "network_number")
    private String networkNumber;

    /**
     * 营业网点名称
     */
    @ExcelProperty("营业网点名称")
    @Column(value = "network_name")
    private String networkName;

    /**
     * 营业网点地址
     */
    @ExcelProperty("营业网点地址")
    @Column(value = "network_address")
    private String networkAddress;

    /**
     * 营业网点所在区县
     */
    @ExcelProperty("营业网点所在区县")
    @Column(value = "network_county")
    private String networkCounty;

    /**
     * 营业网点类型
     */
    @ExcelProperty("营业网点类型")
    @Column(value = "network_type")
    private String networkType;

    /**
     * 开通商编号
     */
    @ExcelProperty("开通商编号")
    @Column(value = "opener_number")
    private String openerNumber;

    /**
     * 电信企业交易流水账单号
     */
    @ExcelProperty("电信企业交易流水账单号")
    @Column(value = "bill_number")
    private String billNumber;

    /**
     * 交易平台用户帐号
     */
    @ExcelProperty("交易平台用户帐号")
    @Column(value = "user_account")
    private String userAccount;

    /**
     * 用户交易的银行卡卡号或第三方支付帐号名称
     */
    @ExcelProperty("用户交易的银行卡卡号或第三方支付帐号名称")
    @Column(value = "bank_card_number")
    private String bankCardNumber;

    /**
     * 支付时间
     */
    @ExcelProperty("支付时间")
    @Column(value = "pay_time")
    private String payTime;

    /**
     * 机主证件电子复印件图片名称
     */
    @ExcelProperty("机主证件电子复印件图片名称")
    @Column(value = "owner_img_name")
    private String ownerImgName;

    /**
     * 代办人证件电子复印件图片名称
     */
    @ExcelProperty("代办人证件电子复印件图片名称")
    @Column(value = "agent_img_name")
    private String agentImgName;

    /**
     * 客户类型
     */
    @ExcelProperty("客户类型")
    @Column(value = "customer_type")
    private String customerType;

    /**
     * 渠道类型
     */
    @ExcelProperty("渠道类型")
    @Column(value = "channel_type")
    private String channelType;

    /**
     * 业务使用状态
     */
    @ExcelProperty("业务使用状态")
    @Column(value = "business_usa_status")
    private String businessUsaStatus;

    /**
     * 预留字段
     */
    @ExcelProperty("预留字段")
    @Column(value = "reserved_field")
    private String reservedField;

}
